package com.hrp.hrpdao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;

import java.util.List;
import java.util.Map;

/**
 * Created by Administrator on 2018-11-24.
 */
@Mapper
public interface HljjDao {

    @Options(statementType= StatementType.CALLABLE)
    @Select({ "exec caculate_jj_hl #{zqid}" })
    Integer caculateJJ(Map<String,Integer> params);

    @Select("select * from JX_KHZBK_TEMP_D_HL where zqid=#{zqid}")
    List<Map<String,Object>> getHljj(@Param("zqid") Integer zqid);
}
